﻿CREATE TABLE [dbo].[Users] (
    [Id]         INT          IDENTITY (1, 1) NOT NULL,
    [IdUserType] INT          NOT NULL,
    [EMail]      VARCHAR (50) NOT NULL,
    [Password]   VARCHAR (50) NOT NULL,
    CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_Users_UserTypes] FOREIGN KEY ([IdUserType]) REFERENCES [dbo].[UserTypes] ([Id])
);

